Sample INSERT statement for a line representing cable with owner and address propertied:

INSERT INTO CABLE VALUES (1, 'Smith', 'John', 'Stockton Drive', 'Exton', 'PA', 19341, MDSYS.SDO_GEOMETRY
m(0012 8307,  NULL,m
sMDSYS.SDO_ELEM_INFO_ARRY(1,2,1)
yMDSYS.SDO_ORDINATE_ARRAY(10,10 20,20 30,30 40,40

Sample INSERT statement for a polygon repesenting a land parcel belonging to John Smith with a value of $350,000 and an ID of 1101.

INSERT INTO PARCELS VALUES('John Smith', '350000', '1101', MDSYS.SDO_GEOMETRY
((003,  2145,
 ULL,
 DSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),
 DSYS.SDO_ORDINATE_ARRAY (3,3,6,3,6,5,4,5,3,3) ;

Sample INSERT statement for a manhole represented by a point:

INSERT INTO MANHOLES VALUES ('1923', '12', 'Utilities', MDSYS.SDO_GEOMETRY( 
3001, 352257, 
MDSYS.SDO_POINT_TYPE(521030,240120,550), null,null));